KeystoneJS Prisma Migration

migrating an existing PostGreSQL database with the KeystoneJS ORM takes a bit of doc reading. Essentially mashing the Command Line - Keystone 6 Docs and link articles together

while in the ./backend keystonejs root directory

mkdir -p migrations/0_init

npx prisma migrate diff \
--from-empty \
--to-schema-datamodel schema.prisma \
--script > migrations/0_init/migration.sql

npx prisma migrate resolve --applied 0_init

run below command to double check

yarn keystone build && keystone prisma migrate deploy

File tree for reference

.
├── Dockerfile
├── README.md
├── access.ts
├── auth.ts
├── crontab
│   └── subscription_cron.ts
├── keystone.ts
├── migrations
│   └── 0_initial
				migration.sql <---- ** here
├── mutations
│   ├── addToCart.ts
│   ├── checkout.ts
│   ├── contact.ts
│   └── sampleMutation.ts
├── package.json
├── prepareToUpload.ts
├── public
│   ├── assets
│   ├── seedfiles
│   └── styles
├── schema.graphql
├── schema.prisma
├── schema.ts
├── schemas
├── tsconfig.json
├── types.ts
└── yarn.lock

Still not working